You can get information about one of the following aspects of this package by
pressing on the corresponding titles, otherwise press on the button "Exit Help".
Introduction
Relation "Cataloginventory"
Relation "Catalogvalues"
Relation "Catalog"
E Exit Help
Credits and Copyright
E About Michael's Stamp Collection
P.S.: Do not be surprised if you can't read the help screen when there is no record present in the relation. Since the help pages are just layouts, they wont show then (that is the reason for the dummy entry inBa the delivered package). Just add a new empty record and you will be able to read the help again.
Version 1.0
Maintaining a Catalog
A|For information about the other files of the package (i.e., inventory, trading), please read their
corresponding help pages.
Help IntroB
E About Michael's Stamp Collection
E About Michael's Stamp Collection
You can maintain all your stamps in one set of relations, or you can make copies of the set for each continent, country or motive. You can add your own fields or layouts to maintain a mixed world
wide and motive collection etc.
Michael's Stamp Collection package is copyrighted by its author and is distributed as ShareWare. That means, you can try it out for one month. After that you either have to erase all copies from your disk or yB
ou have to register your copy with the author by sending either 15 $US or stamps (used or mint) from any country having an equivalent value to:
If you have further questions or suggestions for improvements, you can contact the author at the address above or per electronic mail at:
Registered users will receive the current version and all minor updates (i.e., versions with the same number before the point) for free.
rys@inf.ethz.ch
E Exit Help
Back to Main Help
Relation "Cataloginventory"
The relations are modelled to guarantee as much data consistency as possible. In a relational data model they would satisfy the third normal form (unfortunately FileMaker is far from being a relational DBMS).(*B
Actually, the relation "Catalogvalues" does not even satisfy the second normal form, since the attribut Date of Issue depends only on a part of the key. But since I don't think that this attribute is very imporB
tant, I did not want to create yet another relation just for this attribute. If you have problems with that, please contact me and I will see whether they justify the effort.
It will be free to people who maintain a catalog of a whole area (e.g., country, motive) and
send regular updates to the author. Please see Maintaining a catalog for more information.
E5Michael Rys
Winzerhalde 16
8049 Z
Switzerland
%ining one or two sets of attributes (called a relation). These relations can be used to maintain an electronic inventory of your stamp coBQllection, a want or trade list, a trade inventory or even a full stamp catalog.
E5Michael Rys
Winzerhalde 16
8049 Z
Switzerland
Maintaining a Catalog
Help CataloginventoryB
E About Michael's Stamp Collection
The concatenation of the fields Country, Category and Cat# forms an invisible field which acts as the key of the relation. The record number is attach automatically and corresponds to the number of the dataset.
Michael's Stamp Collection package is copyrighted by its author and is distributed as ShareWare. That means you can try it out for about one months time, after that you either erase all copies from your disk orBy you register your copy with the author by sending either 10 $US or mint stamps from any country matching that amount to:
E Exit Help
Back to Main Help
EFThe following is an example record of the relation "Cataloginventory".
Be aware that all the entries must have a unique key. In order to ensure the key's uniqueness, you have to check this yourself (cf your FileMaker handbook). Unfortunatly FielMaker does not allow to specify uniqueness for a computed field.
Relation "Catalogvalues"
Help CatalogvaluesB
E About Michael's Stamp Collection
Michael's Stamp Collection package is copyrighted by its author and is distributed as ShareWare. That means you can try it out for about one months time, after that you either erase all copies from your disk orBy you register your copy with the author by sending either 10 $US or mint stamps from any country matching that amount to:
E Exit Help
Back to Main Help
Relation "Catalog"
EkThe following is an example record of the relation "Catalogvalues" which is a layout in the file "Catalog".
Be aware that all the entries must have a unique key. In order to ensure the key's uniqueness, you have to check this yourself (cf your FileMaker handbook). Unfortunately FileMaker doesn't allow you to specify uniqueness for a computed field.
Country
Category
Date of Issue
Shade
Paper
Others
used vs mint
Catalog value
E9Contains the name of the issuing country (or the motive).
Certain stamps of a country may be cataloged differently. For example US Air Mail in a Scott catalog. Enter your abbrevation. It is recommended to leave the field blank for the normal cataloged stamps.
EFThis field contains the number of your favorite catalog (or your own).
This is the date of issue of that particular stamp in the format yyyy-mmm-dd (you may have to enter it differently, e.g., dd.mm.yy).
These fields contain information which may further differenciate a special stamp. For example a coil stamp on phosphorated paper gets a C in the field Perf and a y in Paper. If the stamp is identified by its nuB2mber and category, these fields can be left blank.
This field offers a popup menu which contains the way of how you collect the stamp (i.e., FDC, single, Block of 4). You can add your own values to the list (see your FileMaker Manual).
EzThe popup menu of this fields lets you enter the condition of your stamp. Per default the following options are available:
cancelled to order
E.mint with 100% intact gum (no signs of hinges)
mint with signs of hinges
mint without gum
E/The value of the stamp as given in the catalog.
Catalog
The concatenation of the fields Country, Category, Cat#, Color, Paper, Perf, Wm, Type, Kind and used vs mint forms an invisible field which acts as the key of the relation.
Please note: FileMaker Pro V1.0 hasB
a maximal limit of characters for index entries which are used for doing the look
up. Therefore only parts (beginning or
ending characters etc.) are catenated to form this key (see the definition of the field
InventKey). In case you get a wrong look-up it could be that an ambivalent key was created. E.g., keep the first four characters of the Country field and the first two characters of the Category field unique foD6r different countries and categories in the same file.
Help CopyrightB
E About Michael's Stamp Collection
1991
1994 by Michael Rys
All rights reserved. The use for non-commercial activities as for the purpose of trading stamps is explicitely granted. All other usage has to get special permission by the author andB
may require an additional fee. Using this product for any purpose not explicitely granted by the author will be prosecuted according to the laws of the author's country.
Single
is distributed as ShareWare. That means, you can try it out for one month. After that you either have to erase all copies from your disk or you have to register your copy with the author by sending either 15 $UBJS or stamps (used or mint) from any country having an equivalent value to:
A5Michael Rys
Winzerhalde 16
8049 Z
Switzerland
If you have further questions or suggestions for improvements, you can contact the author at the address above or per electronic mail at:
Registered users will receive the current version and all minor updates (i.e., versions with the same number before the point) for free.
rys@inf.ethz.ch
E Exit Help
Back to Main Help
E"Michael's Stamp Collection package
version 1.0
This product is offered on an "as is" basis without any warranty or representation, either express or implied, with respect to this product, its quality, performance, merchantability, or fitness for a particula
r purpose. The user is assuming the entire risk as to its quality and performance. In no event shall the author be liable for direct, indirect, special, incidential, or consequential damages of any kind resultiCKng from any defect in the software or its documentation or the use thereof.
22 * mrys
It will be free to people who maintain an ISD catalog of a whole area (e.g., country, motive)
and send regular updates to the author. Please see Maintaining a catalog for more information.
Maintaining a Catalog
Help CatalogB
E About Michael's Stamp Collection
Michael's Stamp Collection package is copyrighted by its author and is distributed as ShareWare. That means you can try it out for about one months time, after that you either erase all copies from your disk orBy you register your copy with the author by sending either 10 $US or mint stamps from any country matching that amount to:
E=The following is an example record of the relation "Catalog".
Please read the sections on the relations "Cataloginventory" and "Catalogvalues" for a description of the fields. You can enter values which are not referenced from the Cataloginventory either into the fields oBDf the relation "Catalogvalues" or into the fields of this relation.
This relation is actually designed to be the view of the join of the two relations "Cataloginventory" and "Catalogvalues". To generate your personal catalog, all you have to do is following these steps:
E(Make sure that all records are selected.
AmTab to the Country field, press the button "Repeat References" and
voila
there is your homemade catalog.
E Exit Help
Back to Main Help
If you want to create several catalog copies in different files (e.g., for different countries) you have to make sure, that the references in the field definitions are set to the correct files. See your FileMaker Manual for further information.
21.4.1993
21.4.1993
EWThe dates in the lower left corner indicate creation date and last update of the entry.
Maintaining a Catalog
E6The Sort command sorts the currently selected records.
Table CatalogvaluesB
JaFf`
Nein`
JaFf`
Nein`
E)Michael's Stamp Collection: Catalogvalues
Country
Catalog value
used vs mint
Category
Shade
Paper
Others
Date of Issue
Catalog
Maintaining a CatalogB
E About Michael's Stamp Collection
E Exit Help
Back to Main Help
Most catalog suppliers do have a copyright on their catalog numbering system. They normally allow usage for private or trading purposes, but I doubt that this ShareWare package would fall under this topic if itB5 would be distributed with catalog numbering schemes.
The other problem is that there are different standard catalogs for the same country depending on the collector's preferences (e.g., Michel vs. Scott for USA) and of course the language to be used for descriptions.
Because of these reasons I am not including any full catalog and hope that we might come up with either our own catalog for a certain country or get the agreement of the catalog publishers.
However, I don't think it is forbidden, if you type in all the catalog information yourself for your own and solely private use.
In case that you maintain a catalog which can be made available to the public, please contact the author who will help you to distribute the catalog to all interested users of the package.
The ISD catalogs
1993 some people joined there efforts to create an ISD (Internet Stamp Database) standard which gives an Internet wide stamp database standard. This package supports the creation, maintenance and usage of suchC
catalogs.
If you would like to receive more information about the ISD project and about available catalogs please contact the author.
SearchesB
Category
Category
Shade
Paper
Others
TAB to the Country field
Comment
Quantity
AltID
EofCmt
Colour
ListB
Country
Categ
Country
Categ
Shade
Paper
Others
Denom
Descr
AltID
Comment
EofCmt
(C.)EVPresidents of the USA: Andrew Jackson (1767-1845), 7th President 1829-1837, Scott #812
Exit Help
Create Catalog
Create Catalog
A Exit Help
Just to prevent copying
JaFf`
Nein`
Helvetica
Geneva
N Helvetica Narrow
Times
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
3333D
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
Helvetica
$Press here to get to the
helpscreens
\8Press any of the butt
[>ons to execute the assigned command
JaFf`
Nein`
DATE OF ISSUE
singleG
USA-419S
04.08.38V
US-419-b--A---gle0\
22.04.93]
25.07.1994^
USA-419-b--A---glee
brown
(C.)EVPresidents of the USA: Andrew Jackson (1767-1845), 7th President 1829-1837, Scott #81219-b--A---FDC
Single
Usa-419
Us-419-b--a---fdc0
Us-419-b--a---gle0
Pro 1.0F!
Pro 2.0I
Deutsches W
rterbuch
Usa-419-b--a---fdc
Usa-419-b--a---gle
Brown
23.04.93
Pro 2.0I
Deutsches W
rterbuch
336 7
38:;:
CD,@<9EF
8%GHI<3&J!
<89.88UV
YXWYZYX[X
/\[_(
([[Y^`8ROU
[aM[(
/"aN/g8/
![Y[i
6kl6k"U
R.jMYMY/
a]m6]
p3q /
qiiNq
Yir"N1[U
Y[/]3<UU
/ea`]st[g
g1XUkM[i
gO.]U
[guqvj
i/=O][OUU
N]?ja]]
Y[Ya[N
[WYXY
1y3zY
!["[[a
ig]68O%]
"aN]"
M""iz.Uq83U
[aCR]p{'(9>|
3UNrUniUf
/n339U
}YUUqgjU
NrU"as[N
]sdNc
]Na/]33iq
"N[ag"YY
[ciUq]"ar8qiO
a~]YY%
1UYa[[a
U.<yOg
U8UiUY[
al"wUYUOO1a=]a1
qU"a"Y]
{{U/"a[N
["[YYN
NY[iqYar?]ja[a"a
a6.g]l[q
UNa=%]j
YYM }/
86ugz8N
N/a[[
]3R%"
uqjc]tsljO'kca]
]Yd<y
aika]zzOOqgijOO68][]aa"[]9P
\aqk]
UY[8%
U?"]N
aelU8=O
ij]ga
gr]ilN]8/[ic
O[]"Y
Ycjo1U][]jjO8<ua"aa]iNen
[rbjz]]aYa<
} M"g]ailz%"[iq=
i1qqX]
U[diYj]]aaga1
a/]3/
p3qM[Y
3ka]iOO
U"c]][q3
eqg?N8q1gNg"n/c"a
g81>b
3U/[Y
U.88q
Yi!O].jaoam]j
9U[61
g336j
XrUY[/
a[Na[[Na[X[Na[/[
dUM][Y
Ygjij.Uza
N"N[a[
[aa"aa]Na
[]"]]a
/[c]ka
YN[[a
[a]a"[
aa"aNa"
WYC8j
[*]jjk
"a"caa"gkkug]ca][]a]a"
["a]]c]a
c]aa[c"
a"[]a
W~zYaaY[LL
aq88qUjj]Y
]auca
[ "a[
]8$nU
cNa[LL
it=8Ulik
aN[[a]]"ga]a"[
aca"[]""
a YaiOaiU
kaNa[[]c"a"c"
[;aY}
LcqiaYNiNYa
[gzOY
a""]c"ac"a
g]auac"]N"a"aY]3"
<8i[["[aaY
izjjqqM/N[[
a"aa"N
[+Ya[c
[]Naac
Naa]gcaa
NaNa"[a]
]3<Oq
a[cMaYcgigYY
NN"a"c
LcjY[a
kqU"a[NaaN"[N[[a"
Y[cgij]Y["a
aa[[Na"a"a]
[Y[[Y[]"aY
aN"c]a"g
8jYN"
[cgc]a
c"a[]
["[caaY
c[YM
]cN"aN[]a]N]aa]aaNa"aaNi3C
Xr1/aa[[
izzqk]ca
a[N[aaNa
c]caaN[NiyO
a"[a[[
zU8zg"]cc
a"ca[
[a[]]"aa"a"a"aN[][Na"]gg
/6lY[
]qzzU
aaN[]a"
68qM[
UUzU6cc
gqzkj
a["]a"
a"[ik
"icq]k"ciajq//"a[
UqUz88zzqz
cc]"a/
Y[cNaN[a]c]aZ
]k3<?U
i<8<8zzUjz
6q8i]i
Yg]g]Ug?y
jdqvq8U
"["a[[]a"[
MMgU8z6
U6UgzziccYc[kccac
nq1agqtgqOc]iY["["cc]a]
jU8ia
[i"[a[N
"]"a[]Y[
ggc/]U
c/aaY
LLayy688UjzUizkazqa
[[a"[[al
q11b"aka8cg]q]
aN["Yg3;//
C3q/a
z338OUj3zz6u
cjU6U]]%]%k
gj]i]gg]acaa
q38fk
8863388zUqz6k]a[[
[N[N[M]<39k
?lY[a[Y[[Y[[
~@<33
UzUlzk[a][[g]]["[
Ni<?Nk
c]c"a[[
CC88O8
z6U"[]a[[c]a[a
c[["Yi8
MMXam
cac"[N[a
[a[[a
acgNg6
8<]YY
[MMWWMW
R3C3R:"a"
Yg<:)Y
[[aYM
"]a[c
Na[N["a/<
c3yB"
[Yaa]
Y8U[a
[aY]gNY
["]a[
]CSNq
vU/["c/
c[lz"[
a<88k[8zq][33
kcz38z
88<Naa[a
z6[Y[
a6" Y[
aaz]u
["aca
NU.N[
[YY/]
Y[Y[Nz
Y*az1q
1CQ-"
[8iY[YY
k"\bY'|
XYUNd8
YYz]N["
a8]Ng
Na[8aM
O][aUpCOY
NN]abN[[
]"a]a
Y[a[a
bN[Y[
[["a]aaN
p81MY
Y aYYMY
86<8zU8z886
88:8866R
636U5<<3<R633
<36<<8686<y<<3R6C8O
33<<y88<yy<83<8<683
Cp{C83{y<3R
3C{<83
<33y{y<Cppy
]y<<b
.83" qC36
@?^q{CC
<1Mm<R
Brown
9-1837
Andrew
Jackson
President
Presidents
Scott
USA-419S
04.08.38V
US-419-b--A---FDC0\
23.04.93]
25.07.1994^
USA-419-b--A---FDCe
brown
Pro 1.0F!
Pro 2.0I
Deutsches W
rterbuch
Anwenderw
rterbuchch
Michael's Stamp Collection package contains 6 FileMaker files each containing one or two sets of attributes (called a relation). These relations can be used to maintain an electronic inventory of your stamp coBQllection, a want or trade list, a trade inventory or even a full stamp catalog.
(.txt)